home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / acctdaytotals.sql next >
Text File  |  2000-05-12  |  663b  |  20 lines
  1. /* RCSVER $Id: acctdaytotals.sql,v 1.1 1999-03-19 11:22:02-06 evan CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        cashboxcount
  6. * Date:        1/10/1999
  7. * memo:        Evan M. Ghormley    
  8. * Description:    Create the cashboxcount table. 
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE acctdaytotals
  12. (
  13.       acctday_total_seq_num NUMBER(38) PRIMARY KEY,    
  14.       acct_date          DATE,
  15.     coin_total           NUMBER(20,2),
  16.     bill_total             NUMBER(20,2),
  17.     grand_total           NUMBER(20,2)
  18. );
  19.  
  20.